/* ORI FIPS Crosswalk cleaning .do file
Files used: ORI_FIPS_CROSSWALK.dta
Files created: ORI_FIPS_CROSSWALK_clean.dta
Programs used: clean_ORI.do
*/
********************************************************************************

** Clean ORI_FIPS_CROSSWALK

use "Raw Data/UCR/Crosswalk Data/ORI_FIPS_CROSSWALK.dta", clear

*drop missing ORIs (-1)
drop if ori9 == "-1"
drop if ori7 == "-1"

*keep relevant variables
keep ori7 ori9 fips fips_st statename 

save "Raw Data/UCR/Crosswalk Data/ORI_FIPS_CROSSWALK_clean_UCR.dta", replace
